Raw Energy File Profiling Report

Dataset statistics

Number of variables	11
Number of observations	55440
Missing cells	61134
Missing cells (%)	10.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	11.1 MiB
Average record size in memory	209.1 B

Variable types

Numeric	9
Categorical	2

Alerts

`Country` has a high cardinality: 231 distinct values	High cardinality
`Unnamed: 0` is highly correlated with `Year`	High correlation
`Year` is highly correlated with `Unnamed: 0`	High correlation
`Energy_consumption` is highly correlated with `Energy_production` and 3 other fields	High correlation
`Energy_production` is highly correlated with `Energy_consumption` and 2 other fields	High correlation
`GDP` is highly correlated with `Energy_consumption` and 2 other fields	High correlation
`Population` is highly correlated with `Energy_consumption` and 2 other fields	High correlation
`Energy_intensity_per_capita` is highly correlated with `Energy_intensity_by_GDP`	High correlation
`Energy_intensity_by_GDP` is highly correlated with `Energy_intensity_per_capita`	High correlation
`CO2_emission` is highly correlated with `Energy_consumption`	High correlation
`Unnamed: 0` is highly correlated with `Year`	High correlation
`Year` is highly correlated with `Unnamed: 0`	High correlation
`Energy_consumption` is highly correlated with `Energy_production` and 3 other fields	High correlation
`Energy_production` is highly correlated with `Energy_consumption` and 3 other fields	High correlation
`GDP` is highly correlated with `Energy_consumption` and 3 other fields	High correlation
`Population` is highly correlated with `Energy_consumption` and 3 other fields	High correlation
`CO2_emission` is highly correlated with `Energy_consumption` and 3 other fields	High correlation
`Unnamed: 0` is highly correlated with `Year`	High correlation
`Year` is highly correlated with `Unnamed: 0`	High correlation
`Energy_consumption` is highly correlated with `Energy_production` and 2 other fields	High correlation
`Energy_production` is highly correlated with `Energy_consumption`	High correlation
`GDP` is highly correlated with `Energy_consumption` and 1 other fields	High correlation
`Population` is highly correlated with `GDP`	High correlation
`Energy_intensity_per_capita` is highly correlated with `Energy_intensity_by_GDP`	High correlation
`Energy_intensity_by_GDP` is highly correlated with `Energy_intensity_per_capita`	High correlation
`CO2_emission` is highly correlated with `Energy_consumption`	High correlation
`Unnamed: 0` is highly correlated with `Year`	High correlation
`Year` is highly correlated with `Unnamed: 0`	High correlation
`Energy_consumption` is highly correlated with `Energy_production` and 3 other fields	High correlation
`Energy_production` is highly correlated with `Energy_consumption` and 3 other fields	High correlation
`GDP` is highly correlated with `Energy_consumption` and 3 other fields	High correlation
`Population` is highly correlated with `Energy_consumption` and 3 other fields	High correlation
`CO2_emission` is highly correlated with `Energy_consumption` and 3 other fields	High correlation
`Energy_consumption` has 11153 (20.1%) missing values	Missing
`Energy_production` has 11151 (20.1%) missing values	Missing
`GDP` has 15414 (27.8%) missing values	Missing
`Population` has 9426 (17.0%) missing values	Missing
`Energy_intensity_per_capita` has 5082 (9.2%) missing values	Missing
`Energy_intensity_by_GDP` has 5082 (9.2%) missing values	Missing
`CO2_emission` has 3826 (6.9%) missing values	Missing
`Energy_consumption` is highly skewed (γ1 = 23.92149736)	Skewed
`Energy_production` is highly skewed (γ1 = 24.16400807)	Skewed
`CO2_emission` is highly skewed (γ1 = 24.07524101)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Country` is uniformly distributed	Uniform
`Energy_type` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`Energy_consumption` has 10995 (19.8%) zeros	Zeros
`Energy_production` has 20002 (36.1%) zeros	Zeros
`Energy_intensity_per_capita` has 5784 (10.4%) zeros	Zeros
`Energy_intensity_by_GDP` has 11442 (20.6%) zeros	Zeros
`CO2_emission` has 26954 (48.6%) zeros	Zeros

Reproduction

Analysis started	2022-06-19 08:44:22.842702
Analysis finished	2022-06-19 08:45:05.736079
Duration	42.89 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	55440
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27719.5

Minimum	0
Maximum	55439
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	433.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2771.95
Q1	13859.75
median	27719.5
Q3	41579.25
95-th percentile	52667.05
Maximum	55439
Range	55439
Interquartile range (IQR)	27719.5

Descriptive statistics

Standard deviation	16004.2938
Coefficient of variation (CV)	0.5773658904
Kurtosis	-1.2
Mean	27719.5
Median Absolute Deviation (MAD)	13860
Skewness	0
Sum	1536769080
Variance	256137420
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
36964	1	< 0.1%
36953	1	< 0.1%
36954	1	< 0.1%
36955	1	< 0.1%
36956	1	< 0.1%
36957	1	< 0.1%
36958	1	< 0.1%
36959	1	< 0.1%
36960	1	< 0.1%
Other values (55430)	55430	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
55439	1	< 0.1%
55438	1	< 0.1%
55437	1	< 0.1%
55436	1	< 0.1%
55435	1	< 0.1%
55434	1	< 0.1%
55433	1	< 0.1%
55432	1	< 0.1%
55431	1	< 0.1%
55430	1	< 0.1%

Country
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	231
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

World	240
Netherlands Antilles	240
New Zealand	240
Nicaragua	240
Niger	240
Other values (226)	54240

Length

Max length	28
Median length	23
Mean length	9.402597403
Min length	4

Characters and Unicode

Total characters	521280
Distinct characters	58
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	World
2nd row	World
3rd row	World
4th row	World
5th row	World

Common Values

Value	Count	Frequency (%)
World	240	0.4%
Netherlands Antilles	240	0.4%
New Zealand	240	0.4%
Nicaragua	240	0.4%
Niger	240	0.4%
Nigeria	240	0.4%
Niue	240	0.4%
North Korea	240	0.4%
North Macedonia	240	0.4%
Northern Mariana Islands	240	0.4%
Other values (221)	53040	95.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
islands	2400	3.2%
and	1920	2.6%
saint	1200	1.6%
former	960	1.3%
new	720	1.0%
u.s	720	1.0%
germany	720	1.0%
south	720	1.0%
guinea	720	1.0%
republic	720	1.0%
Other values (255)	64320	85.6%

Most occurring characters

Value	Count	Frequency (%)
a	74880	14.4%
i	43440	8.3%
n	41520	8.0%
e	37200	7.1%
r	32160	6.2%
o	27600	5.3%
s	20160	3.9%
	19680	3.8%
t	19200	3.7%
l	18960	3.6%
Other values (48)	186480	35.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	421200	80.8%
Uppercase Letter	75840	14.5%
Space Separator	19680	3.8%
Other Punctuation	3360	0.6%
Dash Punctuation	960	0.2%
Final Punctuation	240	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	74880	17.8%
i	43440	10.3%
n	41520	9.9%
e	37200	8.8%
r	32160	7.6%
o	27600	6.6%
s	20160	4.8%
t	19200	4.6%
l	18960	4.5%
u	18720	4.4%
Other values (17)	87360	20.7%

Uppercase Letter

Value	Count	Frequency (%)
S	9120	12.0%
C	5520	7.3%
B	5520	7.3%
M	5280	7.0%
G	5040	6.6%
I	4800	6.3%
T	4800	6.3%
A	4320	5.7%
N	4080	5.4%
P	3360	4.4%
Other values (15)	24000	31.6%

Other Punctuation

Value	Count	Frequency (%)
.	2400	71.4%
,	720	21.4%
/	240	7.1%

Space Separator

Value	Count	Frequency (%)
	19680	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	960	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	240	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	497040	95.3%
Common	24240	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	74880	15.1%
i	43440	8.7%
n	41520	8.4%
e	37200	7.5%
r	32160	6.5%
o	27600	5.6%
s	20160	4.1%
t	19200	3.9%
l	18960	3.8%
u	18720	3.8%
Other values (42)	163200	32.8%

Common

Value	Count	Frequency (%)
	19680	81.2%
.	2400	9.9%
-	960	4.0%
,	720	3.0%
/	240	1.0%
’	240	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	520800	99.9%
None	240	< 0.1%
Punctuation	240	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	74880	14.4%
i	43440	8.3%
n	41520	8.0%
e	37200	7.1%
r	32160	6.2%
o	27600	5.3%
s	20160	3.9%
	19680	3.8%
t	19200	3.7%
l	18960	3.6%
Other values (46)	186000	35.7%

None

Value	Count	Frequency (%)
ô	240	100.0%

Punctuation

Value	Count	Frequency (%)
’	240	100.0%

Energy_type
Categorical

UNIFORM

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

all_energy_types	9240
coal	9240
natural_gas	9240
petroleum_n_other_liquids	9240
nuclear	9240

Length

Max length	25
Median length	13.5
Mean length	13.5
Min length	4

Characters and Unicode

Total characters	748440
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	all_energy_types
2nd row	coal
3rd row	natural_gas
4th row	petroleum_n_other_liquids
5th row	nuclear

Common Values

Value	Count	Frequency (%)
all_energy_types	9240	16.7%
coal	9240	16.7%
natural_gas	9240	16.7%
petroleum_n_other_liquids	9240	16.7%
nuclear	9240	16.7%
renewables_n_other	9240	16.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
all_energy_types	9240	16.7%
coal	9240	16.7%
natural_gas	9240	16.7%
petroleum_n_other_liquids	9240	16.7%
nuclear	9240	16.7%
renewables_n_other	9240	16.7%

Most occurring characters

Value	Count	Frequency (%)
e	101640	13.6%
l	73920	9.9%
_	73920	9.9%
a	64680	8.6%
r	64680	8.6%
n	55440	7.4%
t	46200	6.2%
u	36960	4.9%
o	36960	4.9%
s	36960	4.9%
Other values (11)	157080	21.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	674520	90.1%
Connector Punctuation	73920	9.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	101640	15.1%
l	73920	11.0%
a	64680	9.6%
r	64680	9.6%
n	55440	8.2%
t	46200	6.8%
u	36960	5.5%
o	36960	5.5%
s	36960	5.5%
p	18480	2.7%
Other values (10)	138600	20.5%

Connector Punctuation

Value	Count	Frequency (%)
_	73920	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	674520	90.1%
Common	73920	9.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	101640	15.1%
l	73920	11.0%
a	64680	9.6%
r	64680	9.6%
n	55440	8.2%
t	46200	6.8%
u	36960	5.5%
o	36960	5.5%
s	36960	5.5%
p	18480	2.7%
Other values (10)	138600	20.5%

Common

Value	Count	Frequency (%)
_	73920	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	748440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	101640	13.6%
l	73920	9.9%
_	73920	9.9%
a	64680	8.6%
r	64680	8.6%
n	55440	7.4%
t	46200	6.2%
u	36960	4.9%
o	36960	4.9%
s	36960	4.9%
Other values (11)	157080	21.0%

Year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	40
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1999.5

Minimum	1980
Maximum	2019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	433.2 KiB

Quantile statistics

Minimum	1980
5-th percentile	1981.95
Q1	1989.75
median	1999.5
Q3	2009.25
95-th percentile	2017.05
Maximum	2019
Range	39
Interquartile range (IQR)	19.5

Descriptive statistics

Standard deviation	11.54350049
Coefficient of variation (CV)	0.005773193543
Kurtosis	-1.201501073
Mean	1999.5
Median Absolute Deviation (MAD)	10
Skewness	0
Sum	110852280
Variance	133.2524035
Monotonicity	Increasing

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
1980	1386	2.5%
1981	1386	2.5%
2002	1386	2.5%
2003	1386	2.5%
2004	1386	2.5%
2005	1386	2.5%
2006	1386	2.5%
2007	1386	2.5%
2008	1386	2.5%
2009	1386	2.5%
Other values (30)	41580	75.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1980	1386	2.5%
1981	1386	2.5%
1982	1386	2.5%
1983	1386	2.5%
1984	1386	2.5%
1985	1386	2.5%
1986	1386	2.5%
1987	1386	2.5%
1988	1386	2.5%
1989	1386	2.5%

Value	Count	Frequency (%)
2019	1386	2.5%
2018	1386	2.5%
2017	1386	2.5%
2016	1386	2.5%
2015	1386	2.5%
2014	1386	2.5%
2013	1386	2.5%
2012	1386	2.5%
2011	1386	2.5%
2010	1386	2.5%

Energy_consumption
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	30460
Distinct (%)	68.8%
Missing	11153
Missing (%)	20.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.537810796

Minimum	-0.163437731
Maximum	601.04049
Zeros	10995
Zeros (%)	19.8%
Negative	208
Negative (%)	0.4%
Memory size	433.2 KiB

Quantile statistics

Minimum	-0.163437731
5-th percentile	0
Q1	0
median	0.018381028
Q3	0.2094223795
95-th percentile	3.313893286
Maximum	601.04049
Range	601.2039277
Interquartile range (IQR)	0.2094223795

Descriptive statistics

Standard deviation	15.45659646
Coefficient of variation (CV)	10.05103911
Kurtosis	706.4965549
Mean	1.537810796
Median Absolute Deviation (MAD)	0.018381028
Skewness	23.92149736
Sum	68105.02673
Variance	238.9063741
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10995	19.8%
4.34 × 10^-5	44	0.1%
0.003647336	28	0.1%
0.000660772	20	< 0.1%
0.003697481	18	< 0.1%
0.00240206	16	< 0.1%
0.000257563	16	< 0.1%
0.000626523	14	< 0.1%
0.000212613	14	< 0.1%
2.09 × 10^-5	14	< 0.1%
Other values (30450)	33108	59.7%
(Missing)	11153	20.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.163437731	1	< 0.1%
-0.155209063	1	< 0.1%
-0.137970723	1	< 0.1%
-0.134061167	1	< 0.1%
-0.120652059	1	< 0.1%
-0.108294425	1	< 0.1%
-0.105429518	1	< 0.1%
-0.099622429	1	< 0.1%
-0.097200413	1	< 0.1%
-0.088315282	1	< 0.1%

Value	Count	Frequency (%)
601.04049	1	< 0.1%
597.7365823	1	< 0.1%
584.2018163	1	< 0.1%
572.1592307	1	< 0.1%
567.3288218	1	< 0.1%
566.1299422	1	< 0.1%
561.0921506	1	< 0.1%
551.6003834	1	< 0.1%
540.495127	1	< 0.1%
526.7304677	1	< 0.1%

Energy_production
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	20598
Distinct (%)	46.5%
Missing	11151
Missing (%)	20.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.532700012

Minimum	-1 × 10^-39
Maximum	611.5089686
Zeros	20002
Zeros (%)	36.1%
Negative	6
Negative (%)	< 0.1%
Memory size	433.2 KiB

Quantile statistics

Minimum	-1 × 10^-39
5-th percentile	0
Q1	0
median	0.000512197
Q3	0.112541005
95-th percentile	3.835083374
Maximum	611.5089686
Range	611.5089686
Interquartile range (IQR)	0.112541005

Descriptive statistics

Standard deviation	15.30355613
Coefficient of variation (CV)	9.984704125
Kurtosis	720.5210157
Mean	1.532700012
Median Absolute Deviation (MAD)	0.000512197
Skewness	24.16400807
Sum	67881.75082
Variance	234.1988302
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20002	36.1%
2.09 × 10^-5	31	0.1%
1.9 × 10^-5	18	< 0.1%
1.95 × 10^-5	16	< 0.1%
1.98 × 10^-5	16	< 0.1%
0.002146198	16	< 0.1%
2.06 × 10^-5	15	< 0.1%
2.08 × 10^-5	14	< 0.1%
0.002145788	14	< 0.1%
0.003697481	14	< 0.1%
Other values (20588)	24133	43.5%
(Missing)	11151	20.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1 × 10^-39	6	< 0.1%
0	20002	36.1%
1 × 10^-39	3	< 0.1%
1.86 × 10^-18	1	< 0.1%
1 × 10^-7	2	< 0.1%
2.98 × 10^-7	2	< 0.1%
8.29 × 10^-7	1	< 0.1%
9.51 × 10^-7	1	< 0.1%
9.52 × 10^-7	4	< 0.1%
9.54 × 10^-7	3	< 0.1%

Value	Count	Frequency (%)
611.5089686	1	< 0.1%
600.7287295	1	< 0.1%
578.2452544	1	< 0.1%
568.558292	1	< 0.1%
564.5802759	1	< 0.1%
563.3312419	1	< 0.1%
554.177553	1	< 0.1%
546.3336054	1	< 0.1%
534.1878726	1	< 0.1%
518.7316575	1	< 0.1%

GDP
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	6653
Distinct (%)	16.6%
Missing	15414
Missing (%)	27.8%
Infinite	0
Infinite (%)	0.0%
Mean	827.1441264

Minimum	0.124958
Maximum	127690.2471
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	433.2 KiB

Quantile statistics

Minimum	0.124958
5-th percentile	1.01847
Q1	9.73778
median	47.7571
Q3	263.6871
95-th percentile	2030.632
Maximum	127690.2471
Range	127690.1221
Interquartile range (IQR)	253.94932

Descriptive statistics

Standard deviation	5981.703144
Coefficient of variation (CV)	7.231754362
Kurtosis	235.688449
Mean	827.1441264
Median Absolute Deviation (MAD)	45.24724
Skewness	14.48246875
Sum	33107270.8
Variance	35780772.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
177.6304	36	0.1%
36.3687	12	< 0.1%
1.26052	12	< 0.1%
5.617	12	< 0.1%
14.715	12	< 0.1%
181.306	12	< 0.1%
7.59531	12	< 0.1%
10.6496	12	< 0.1%
17.3494	12	< 0.1%
15.8517	12	< 0.1%
Other values (6643)	39882	71.9%
(Missing)	15414	27.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.124958	6	< 0.1%
0.127624	6	< 0.1%
0.135649	6	< 0.1%
0.135902	6	< 0.1%
0.136654	6	< 0.1%
0.13669	6	< 0.1%
0.137598	6	< 0.1%
0.138485	6	< 0.1%
0.141736	6	< 0.1%
0.145078	6	< 0.1%

Value	Count	Frequency (%)
127690.2471	6	< 0.1%
124161.994	6	< 0.1%
119854.3217	6	< 0.1%
115567.8801	6	< 0.1%
111935.8957	6	< 0.1%
108404.1799	6	< 0.1%
104859.4489	6	< 0.1%
101534.1126	6	< 0.1%
98369.0322	6	< 0.1%
94617.52644	6	< 0.1%

Population
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	7657
Distinct (%)	16.6%
Missing	9426
Missing (%)	17.0%
Infinite	0
Infinite (%)	0.0%
Mean	62630.20477

Minimum	11.471
Maximum	7714631.064
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	433.2 KiB

Quantile statistics

Minimum	11.471
5-th percentile	89.1382
Q1	1141.95
median	6157.68
Q3	20042.9
95-th percentile	118711.8
Maximum	7714631.064
Range	7714619.593
Interquartile range (IQR)	18900.95

Descriptive statistics

Standard deviation	456208.8203
Coefficient of variation (CV)	7.284166194
Kurtosis	178.4748082
Mean	62630.20477
Median Absolute Deviation (MAD)	5758.731
Skewness	12.93661597
Sum	2881866242
Variance	2.081264878 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
103.776	12	< 0.1%
9941.1	12	< 0.1%
294.976	12	< 0.1%
13066.5	12	< 0.1%
161.676	12	< 0.1%
3453.67	12	< 0.1%
10160	12	< 0.1%
3734.34	12	< 0.1%
11282.7	12	< 0.1%
3559.5	12	< 0.1%
Other values (7647)	45894	82.8%
(Missing)	9426	17.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11.471	6	< 0.1%
11.821	6	< 0.1%
12.25	6	< 0.1%
12.755	6	< 0.1%
13.317	6	< 0.1%
13.951	6	< 0.1%
14.646	6	< 0.1%
15.39	6	< 0.1%
16.155	6	< 0.1%
16.207	6	< 0.1%

Value	Count	Frequency (%)
7714631.064	6	< 0.1%
7632247.012	6	< 0.1%
7548343.789	6	< 0.1%
7464042.846	6	< 0.1%
7379227.32	6	< 0.1%
7297269.981	6	< 0.1%
7211822.209	6	< 0.1%
7126262.294	6	< 0.1%
7041712.689	6	< 0.1%
6948810.014	6	< 0.1%

Energy_intensity_per_capita
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	7430
Distinct (%)	14.8%
Missing	5082
Missing (%)	9.2%
Infinite	0
Infinite (%)	0.0%
Mean	71.8989137

Minimum	0
Maximum	1139.320598
Zeros	5784
Zeros (%)	10.4%
Negative	0
Negative (%)	0.0%
Memory size	433.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3.79993914
median	29.77925957
Q3	95.52362689
95-th percentile	268.0845979
Maximum	1139.320598
Range	1139.320598
Interquartile range (IQR)	91.72368775

Descriptive statistics

Standard deviation	113.7287384
Coefficient of variation (CV)	1.581786602
Kurtosis	17.42699629
Mean	71.8989137
Median Absolute Deviation (MAD)	28.74208029
Skewness	3.441978433
Sum	3620685.496
Variance	12934.22594
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5784	10.4%
68.14592081	6	< 0.1%
128.7796754	6	< 0.1%
36.74813757	6	< 0.1%
83.10244145	6	< 0.1%
8.93068597	6	< 0.1%
42.37612909	6	< 0.1%
493.4825967	6	< 0.1%
9.523323358	6	< 0.1%
5.077479377	6	< 0.1%
Other values (7420)	44520	80.3%
(Missing)	5082	9.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5784	10.4%
0.331847677	6	< 0.1%
0.334977519	6	< 0.1%
0.344453308	6	< 0.1%
0.347076747	6	< 0.1%
0.347198731	6	< 0.1%
0.351858006	6	< 0.1%
0.355312361	6	< 0.1%
0.356964678	6	< 0.1%
0.359532897	6	< 0.1%

Value	Count	Frequency (%)
1139.320598	6	< 0.1%
1127.238553	6	< 0.1%
1115.45434	6	< 0.1%
1110.320147	6	< 0.1%
1106.792855	6	< 0.1%
1101.179716	6	< 0.1%
1095.358362	6	< 0.1%
1082.594019	6	< 0.1%
1053.222783	6	< 0.1%
1027.044351	6	< 0.1%

Energy_intensity_by_GDP
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	6486
Distinct (%)	12.9%
Missing	5082
Missing (%)	9.2%
Infinite	0
Infinite (%)	0.0%
Mean	3.695103863

Minimum	0
Maximum	166.9136046
Zeros	11442
Zeros (%)	20.6%
Negative	0
Negative (%)	0.0%
Memory size	433.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.899446174
median	2.987592599
Q3	4.969454094
95-th percentile	10.32595475
Maximum	166.9136046
Range	166.9136046
Interquartile range (IQR)	4.07000792

Descriptive statistics

Standard deviation	4.5907346
Coefficient of variation (CV)	1.242383102
Kurtosis	328.3645712
Mean	3.695103863
Median Absolute Deviation (MAD)	2.020993165
Skewness	10.91730849
Sum	186078.0403
Variance	21.07484416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11442	20.6%
1.348495877	12	< 0.1%
4.698488907	6	< 0.1%
5.51605109	6	< 0.1%
7.042345664	6	< 0.1%
5.748309383	6	< 0.1%
2.211954797	6	< 0.1%
11.56983774	6	< 0.1%
4.406431928	6	< 0.1%
3.627906627	6	< 0.1%
Other values (6476)	38856	70.1%
(Missing)	5082	9.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11442	20.6%
0.231284987	6	< 0.1%
0.232750534	6	< 0.1%
0.233266614	6	< 0.1%
0.249271625	6	< 0.1%
0.251104537	6	< 0.1%
0.253626906	6	< 0.1%
0.25926694	6	< 0.1%
0.26552571	6	< 0.1%
0.29520933	6	< 0.1%

Value	Count	Frequency (%)
166.9136046	6	< 0.1%
153.4088035	6	< 0.1%
31.8073807	6	< 0.1%
31.75636874	6	< 0.1%
31.2189403	6	< 0.1%
31.14421857	6	< 0.1%
29.73922555	6	< 0.1%
29.59851151	6	< 0.1%
29.17988971	6	< 0.1%
29.15970048	6	< 0.1%

CO2_emission
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	16993
Distinct (%)	32.9%
Missing	3826
Missing (%)	6.9%
Infinite	0
Infinite (%)	0.0%
Mean	78.80008185

Minimum	-0.005130222
Maximum	35584.9335
Zeros	26954
Zeros (%)	48.6%
Negative	3
Negative (%)	< 0.1%
Memory size	433.2 KiB

Quantile statistics

Minimum	-0.005130222
5-th percentile	0
Q1	0
median	0
Q3	4.318822279
95-th percentile	141.829587
Maximum	35584.9335
Range	35584.93863
Interquartile range (IQR)	4.318822279

Descriptive statistics

Standard deviation	902.2214629
Coefficient of variation (CV)	11.44949906
Kurtosis	711.3428978
Mean	78.80008185
Median Absolute Deviation (MAD)	0
Skewness	24.07524101
Sum	4067187.425
Variance	814003.5681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26954	48.6%
0.2	495	0.9%
0.1	355	0.6%
0.3	317	0.6%
0.7	232	0.4%
0.5	227	0.4%
0.4	214	0.4%
0.6	192	0.3%
1	154	0.3%
0.8	139	0.3%
Other values (16983)	22335	40.3%
(Missing)	3826	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.005130222	1	< 0.1%
-0.00307747	1	< 0.1%
-0.000138354	1	< 0.1%
0	26954	48.6%
1.97 × 10^-7	1	< 0.1%
2.78 × 10^-7	1	< 0.1%
8.24 × 10^-7	1	< 0.1%
1.15 × 10^-6	1	< 0.1%
1.23 × 10^-6	1	< 0.1%
1.83 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
35584.9335	1	< 0.1%
35002.90078	1	< 0.1%
34894.26005	1	< 0.1%
34839.90425	1	< 0.1%
34751.60559	1	< 0.1%
34572.3807	1	< 0.1%
34423.41475	1	< 0.1%
33633.32449	1	< 0.1%
32519.30537	1	< 0.1%
30795.45094	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	Country	Energy_type	Year	Energy_consumption	Energy_production	GDP	Population	Energy_intensity_per_capita	Energy_intensity_by_GDP	CO2_emission
0	0	World	all_energy_types	1980	292.899790	296.337228	27770.91028	4298126.522	68.145921	10.547	4946.627130
1	1	World	coal	1980	78.656134	80.114194	27770.91028	4298126.522	68.145921	10.547	1409.790188
2	2	World	natural_gas	1980	53.865223	54.761046	27770.91028	4298126.522	68.145921	10.547	1081.593377
3	3	World	petroleum_n_other_liquids	1980	132.064019	133.111109	27770.91028	4298126.522	68.145921	10.547	2455.243565
4	4	World	nuclear	1980	7.575700	7.575700	27770.91028	4298126.522	68.145921	10.547	0.000000
5	5	World	renewables_n_other	1980	20.702344	20.775178	27770.91028	4298126.522	68.145921	10.547	0.000000
6	6	Afghanistan	all_energy_types	1980	0.026583	0.072561	NaN	13356.500	1.990283	0.000	NaN
7	7	Afghanistan	coal	1980	0.002479	0.002355	NaN	13356.500	1.990283	0.000	NaN
8	8	Afghanistan	natural_gas	1980	0.002094	0.062820	NaN	13356.500	1.990283	0.000	NaN
9	9	Afghanistan	petroleum_n_other_liquids	1980	0.014624	0.000000	NaN	13356.500	1.990283	0.000	NaN

Last rows

	Unnamed: 0	Country	Energy_type	Year	Energy_consumption	Energy_production	GDP	Population	Energy_intensity_per_capita	Energy_intensity_by_GDP	CO2_emission
55430	55430	Zambia	natural_gas	2019	0.000000	0.000000	247.1819	17873.85	11.586567	0.837831	0.000000
55431	55431	Zambia	petroleum_n_other_liquids	2019	0.052135	0.000000	247.1819	17873.85	11.586567	0.837831	4.202188
55432	55432	Zambia	nuclear	2019	NaN	NaN	247.1819	17873.85	11.586567	0.837831	0.000000
55433	55433	Zambia	renewables_n_other	2019	0.120811	0.123466	247.1819	17873.85	11.586567	0.837831	0.000000
55434	55434	Zimbabwe	all_energy_types	2019	0.168651	0.143462	37.6204	14654.20	11.508701	4.482962	8.964759
55435	55435	Zimbabwe	coal	2019	0.045064	0.075963	37.6204	14654.20	11.508701	4.482962	4.586869
55436	55436	Zimbabwe	natural_gas	2019	0.000000	0.000000	37.6204	14654.20	11.508701	4.482962	0.000000
55437	55437	Zimbabwe	petroleum_n_other_liquids	2019	0.055498	0.000000	37.6204	14654.20	11.508701	4.482962	4.377890
55438	55438	Zimbabwe	nuclear	2019	NaN	NaN	37.6204	14654.20	11.508701	4.482962	0.000000
55439	55439	Zimbabwe	renewables_n_other	2019	0.068089	0.067499	37.6204	14654.20	11.508701	4.482962	0.000000

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows